List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:
apply structured query language (SQL) to a relational database and gather required information according to task requirements.
In the course of the above, the candidate must:
generate queries for one or more tables and provide required data
add, modify, retrieve and delete records from database tables as required test and verify SQL statements.
The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:
organisational policies and procedures relating to SQL application including:
identifying SQL requirements from job specifications
testing and verifying SQL results
features and application of primary and foreign keys in database tables, aggregate functions and clause functions required in SQL application
principles of "combining and/or condition" in SQL statements and Boolean operators
IN and BETWEEN conditional operators
mathematical operators
table joins (relationships)
documentation techniques relevant to applying structured query language in relational databases
SQL statement testing methodologies.
Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.
This includes access to:
task specification documentation
structured query language (SQL)
industry standard software packages
an integrated development environment (IDE)
a database server
required hardware, software and its component.
Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.